package com.deyuanyun.pic.pipe.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ValveExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ValveExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNull() {
            addCriterion("CREATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNotNull() {
            addCriterion("CREATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkEqualTo(String value) {
            addCriterion("CREATE_REMARK =", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotEqualTo(String value) {
            addCriterion("CREATE_REMARK <>", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThan(String value) {
            addCriterion("CREATE_REMARK >", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK >=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThan(String value) {
            addCriterion("CREATE_REMARK <", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK <=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLike(String value) {
            addCriterion("CREATE_REMARK like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotLike(String value) {
            addCriterion("CREATE_REMARK not like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIn(List<String> values) {
            addCriterion("CREATE_REMARK in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotIn(List<String> values) {
            addCriterion("CREATE_REMARK not in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK not between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNull() {
            addCriterion("UPDATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNotNull() {
            addCriterion("UPDATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkEqualTo(String value) {
            addCriterion("UPDATE_REMARK =", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotEqualTo(String value) {
            addCriterion("UPDATE_REMARK <>", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThan(String value) {
            addCriterion("UPDATE_REMARK >", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK >=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThan(String value) {
            addCriterion("UPDATE_REMARK <", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK <=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLike(String value) {
            addCriterion("UPDATE_REMARK like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotLike(String value) {
            addCriterion("UPDATE_REMARK not like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIn(List<String> values) {
            addCriterion("UPDATE_REMARK in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotIn(List<String> values) {
            addCriterion("UPDATE_REMARK not in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK not between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("DELETED is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("DELETED =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("DELETED <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("DELETED >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETED >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("DELETED <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("DELETED <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("DELETED in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("DELETED not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("DELETED between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("DELETED not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNull() {
            addCriterion("VSERSION is null");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNotNull() {
            addCriterion("VSERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVsersionEqualTo(Short value) {
            addCriterion("VSERSION =", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotEqualTo(Short value) {
            addCriterion("VSERSION <>", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThan(Short value) {
            addCriterion("VSERSION >", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThanOrEqualTo(Short value) {
            addCriterion("VSERSION >=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThan(Short value) {
            addCriterion("VSERSION <", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThanOrEqualTo(Short value) {
            addCriterion("VSERSION <=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionIn(List<Short> values) {
            addCriterion("VSERSION in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotIn(List<Short> values) {
            addCriterion("VSERSION not in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionBetween(Short value1, Short value2) {
            addCriterion("VSERSION between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotBetween(Short value1, Short value2) {
            addCriterion("VSERSION not between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNull() {
            addCriterion("IS_NEWEST is null");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNotNull() {
            addCriterion("IS_NEWEST is not null");
            return (Criteria) this;
        }

        public Criteria andIsNewestEqualTo(Short value) {
            addCriterion("IS_NEWEST =", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotEqualTo(Short value) {
            addCriterion("IS_NEWEST <>", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThan(Short value) {
            addCriterion("IS_NEWEST >", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST >=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThan(Short value) {
            addCriterion("IS_NEWEST <", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST <=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestIn(List<Short> values) {
            addCriterion("IS_NEWEST in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotIn(List<Short> values) {
            addCriterion("IS_NEWEST not in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST not between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNull() {
            addCriterion("DATA_STATED is null");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNotNull() {
            addCriterion("DATA_STATED is not null");
            return (Criteria) this;
        }

        public Criteria andDataStatedEqualTo(String value) {
            addCriterion("DATA_STATED =", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotEqualTo(String value) {
            addCriterion("DATA_STATED <>", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThan(String value) {
            addCriterion("DATA_STATED >", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThanOrEqualTo(String value) {
            addCriterion("DATA_STATED >=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThan(String value) {
            addCriterion("DATA_STATED <", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThanOrEqualTo(String value) {
            addCriterion("DATA_STATED <=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLike(String value) {
            addCriterion("DATA_STATED like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotLike(String value) {
            addCriterion("DATA_STATED not like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedIn(List<String> values) {
            addCriterion("DATA_STATED in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotIn(List<String> values) {
            addCriterion("DATA_STATED not in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedBetween(String value1, String value2) {
            addCriterion("DATA_STATED between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotBetween(String value1, String value2) {
            addCriterion("DATA_STATED not between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNull() {
            addCriterion("PIPE_LINE_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNotNull() {
            addCriterion("PIPE_LINE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdEqualTo(String value) {
            addCriterion("PIPE_LINE_ID =", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <>", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThan(String value) {
            addCriterion("PIPE_LINE_ID >", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID >=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThan(String value) {
            addCriterion("PIPE_LINE_ID <", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLike(String value) {
            addCriterion("PIPE_LINE_ID like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotLike(String value) {
            addCriterion("PIPE_LINE_ID not like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIn(List<String> values) {
            addCriterion("PIPE_LINE_ID in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotIn(List<String> values) {
            addCriterion("PIPE_LINE_ID not in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID not between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdIsNull() {
            addCriterion("PIPE_VALVEROOM_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdIsNotNull() {
            addCriterion("PIPE_VALVEROOM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID =", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID <>", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdGreaterThan(String value) {
            addCriterion("PIPE_VALVEROOM_ID >", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID >=", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdLessThan(String value) {
            addCriterion("PIPE_VALVEROOM_ID <", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_VALVEROOM_ID <=", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdLike(String value) {
            addCriterion("PIPE_VALVEROOM_ID like", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotLike(String value) {
            addCriterion("PIPE_VALVEROOM_ID not like", value, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdIn(List<String> values) {
            addCriterion("PIPE_VALVEROOM_ID in", values, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotIn(List<String> values) {
            addCriterion("PIPE_VALVEROOM_ID not in", values, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdBetween(String value1, String value2) {
            addCriterion("PIPE_VALVEROOM_ID between", value1, value2, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andPipeValveroomIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_VALVEROOM_ID not between", value1, value2, "pipeValveroomId");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andValvaNumberIsNull() {
            addCriterion("VALVA_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andValvaNumberIsNotNull() {
            addCriterion("VALVA_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andValvaNumberEqualTo(String value) {
            addCriterion("VALVA_NUMBER =", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberNotEqualTo(String value) {
            addCriterion("VALVA_NUMBER <>", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberGreaterThan(String value) {
            addCriterion("VALVA_NUMBER >", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberGreaterThanOrEqualTo(String value) {
            addCriterion("VALVA_NUMBER >=", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberLessThan(String value) {
            addCriterion("VALVA_NUMBER <", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberLessThanOrEqualTo(String value) {
            addCriterion("VALVA_NUMBER <=", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberLike(String value) {
            addCriterion("VALVA_NUMBER like", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberNotLike(String value) {
            addCriterion("VALVA_NUMBER not like", value, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberIn(List<String> values) {
            addCriterion("VALVA_NUMBER in", values, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberNotIn(List<String> values) {
            addCriterion("VALVA_NUMBER not in", values, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberBetween(String value1, String value2) {
            addCriterion("VALVA_NUMBER between", value1, value2, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andValvaNumberNotBetween(String value1, String value2) {
            addCriterion("VALVA_NUMBER not between", value1, value2, "valvaNumber");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumIsNull() {
            addCriterion("MANUFACTURED_NUM is null");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumIsNotNull() {
            addCriterion("MANUFACTURED_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM =", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM <>", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumGreaterThan(String value) {
            addCriterion("MANUFACTURED_NUM >", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumGreaterThanOrEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM >=", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumLessThan(String value) {
            addCriterion("MANUFACTURED_NUM <", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumLessThanOrEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM <=", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumLike(String value) {
            addCriterion("MANUFACTURED_NUM like", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotLike(String value) {
            addCriterion("MANUFACTURED_NUM not like", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumIn(List<String> values) {
            addCriterion("MANUFACTURED_NUM in", values, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotIn(List<String> values) {
            addCriterion("MANUFACTURED_NUM not in", values, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumBetween(String value1, String value2) {
            addCriterion("MANUFACTURED_NUM between", value1, value2, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotBetween(String value1, String value2) {
            addCriterion("MANUFACTURED_NUM not between", value1, value2, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andValveStatusIsNull() {
            addCriterion("VALVE_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andValveStatusIsNotNull() {
            addCriterion("VALVE_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andValveStatusEqualTo(String value) {
            addCriterion("VALVE_STATUS =", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusNotEqualTo(String value) {
            addCriterion("VALVE_STATUS <>", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusGreaterThan(String value) {
            addCriterion("VALVE_STATUS >", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusGreaterThanOrEqualTo(String value) {
            addCriterion("VALVE_STATUS >=", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusLessThan(String value) {
            addCriterion("VALVE_STATUS <", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusLessThanOrEqualTo(String value) {
            addCriterion("VALVE_STATUS <=", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusLike(String value) {
            addCriterion("VALVE_STATUS like", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusNotLike(String value) {
            addCriterion("VALVE_STATUS not like", value, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusIn(List<String> values) {
            addCriterion("VALVE_STATUS in", values, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusNotIn(List<String> values) {
            addCriterion("VALVE_STATUS not in", values, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusBetween(String value1, String value2) {
            addCriterion("VALVE_STATUS between", value1, value2, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveStatusNotBetween(String value1, String value2) {
            addCriterion("VALVE_STATUS not between", value1, value2, "valveStatus");
            return (Criteria) this;
        }

        public Criteria andValveTypeIsNull() {
            addCriterion("VALVE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andValveTypeIsNotNull() {
            addCriterion("VALVE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andValveTypeEqualTo(String value) {
            addCriterion("VALVE_TYPE =", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeNotEqualTo(String value) {
            addCriterion("VALVE_TYPE <>", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeGreaterThan(String value) {
            addCriterion("VALVE_TYPE >", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeGreaterThanOrEqualTo(String value) {
            addCriterion("VALVE_TYPE >=", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeLessThan(String value) {
            addCriterion("VALVE_TYPE <", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeLessThanOrEqualTo(String value) {
            addCriterion("VALVE_TYPE <=", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeLike(String value) {
            addCriterion("VALVE_TYPE like", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeNotLike(String value) {
            addCriterion("VALVE_TYPE not like", value, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeIn(List<String> values) {
            addCriterion("VALVE_TYPE in", values, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeNotIn(List<String> values) {
            addCriterion("VALVE_TYPE not in", values, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeBetween(String value1, String value2) {
            addCriterion("VALVE_TYPE between", value1, value2, "valveType");
            return (Criteria) this;
        }

        public Criteria andValveTypeNotBetween(String value1, String value2) {
            addCriterion("VALVE_TYPE not between", value1, value2, "valveType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeIsNull() {
            addCriterion("OPERATOR_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeIsNotNull() {
            addCriterion("OPERATOR_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeEqualTo(String value) {
            addCriterion("OPERATOR_TYPE =", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeNotEqualTo(String value) {
            addCriterion("OPERATOR_TYPE <>", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeGreaterThan(String value) {
            addCriterion("OPERATOR_TYPE >", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeGreaterThanOrEqualTo(String value) {
            addCriterion("OPERATOR_TYPE >=", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeLessThan(String value) {
            addCriterion("OPERATOR_TYPE <", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeLessThanOrEqualTo(String value) {
            addCriterion("OPERATOR_TYPE <=", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeLike(String value) {
            addCriterion("OPERATOR_TYPE like", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeNotLike(String value) {
            addCriterion("OPERATOR_TYPE not like", value, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeIn(List<String> values) {
            addCriterion("OPERATOR_TYPE in", values, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeNotIn(List<String> values) {
            addCriterion("OPERATOR_TYPE not in", values, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeBetween(String value1, String value2) {
            addCriterion("OPERATOR_TYPE between", value1, value2, "operatorType");
            return (Criteria) this;
        }

        public Criteria andOperatorTypeNotBetween(String value1, String value2) {
            addCriterion("OPERATOR_TYPE not between", value1, value2, "operatorType");
            return (Criteria) this;
        }

        public Criteria andAutomatedIsNull() {
            addCriterion("AUTOMATED is null");
            return (Criteria) this;
        }

        public Criteria andAutomatedIsNotNull() {
            addCriterion("AUTOMATED is not null");
            return (Criteria) this;
        }

        public Criteria andAutomatedEqualTo(String value) {
            addCriterion("AUTOMATED =", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedNotEqualTo(String value) {
            addCriterion("AUTOMATED <>", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedGreaterThan(String value) {
            addCriterion("AUTOMATED >", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedGreaterThanOrEqualTo(String value) {
            addCriterion("AUTOMATED >=", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedLessThan(String value) {
            addCriterion("AUTOMATED <", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedLessThanOrEqualTo(String value) {
            addCriterion("AUTOMATED <=", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedLike(String value) {
            addCriterion("AUTOMATED like", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedNotLike(String value) {
            addCriterion("AUTOMATED not like", value, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedIn(List<String> values) {
            addCriterion("AUTOMATED in", values, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedNotIn(List<String> values) {
            addCriterion("AUTOMATED not in", values, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedBetween(String value1, String value2) {
            addCriterion("AUTOMATED between", value1, value2, "automated");
            return (Criteria) this;
        }

        public Criteria andAutomatedNotBetween(String value1, String value2) {
            addCriterion("AUTOMATED not between", value1, value2, "automated");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeIsNull() {
            addCriterion("INLET_CONNECTION_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeIsNotNull() {
            addCriterion("INLET_CONNECTION_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeEqualTo(String value) {
            addCriterion("INLET_CONNECTION_TYPE =", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeNotEqualTo(String value) {
            addCriterion("INLET_CONNECTION_TYPE <>", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeGreaterThan(String value) {
            addCriterion("INLET_CONNECTION_TYPE >", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeGreaterThanOrEqualTo(String value) {
            addCriterion("INLET_CONNECTION_TYPE >=", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeLessThan(String value) {
            addCriterion("INLET_CONNECTION_TYPE <", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeLessThanOrEqualTo(String value) {
            addCriterion("INLET_CONNECTION_TYPE <=", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeLike(String value) {
            addCriterion("INLET_CONNECTION_TYPE like", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeNotLike(String value) {
            addCriterion("INLET_CONNECTION_TYPE not like", value, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeIn(List<String> values) {
            addCriterion("INLET_CONNECTION_TYPE in", values, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeNotIn(List<String> values) {
            addCriterion("INLET_CONNECTION_TYPE not in", values, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeBetween(String value1, String value2) {
            addCriterion("INLET_CONNECTION_TYPE between", value1, value2, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletConnectionTypeNotBetween(String value1, String value2) {
            addCriterion("INLET_CONNECTION_TYPE not between", value1, value2, "inletConnectionType");
            return (Criteria) this;
        }

        public Criteria andInletDiameterIsNull() {
            addCriterion("INLET_DIAMETER is null");
            return (Criteria) this;
        }

        public Criteria andInletDiameterIsNotNull() {
            addCriterion("INLET_DIAMETER is not null");
            return (Criteria) this;
        }

        public Criteria andInletDiameterEqualTo(BigDecimal value) {
            addCriterion("INLET_DIAMETER =", value, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterNotEqualTo(BigDecimal value) {
            addCriterion("INLET_DIAMETER <>", value, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterGreaterThan(BigDecimal value) {
            addCriterion("INLET_DIAMETER >", value, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("INLET_DIAMETER >=", value, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterLessThan(BigDecimal value) {
            addCriterion("INLET_DIAMETER <", value, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterLessThanOrEqualTo(BigDecimal value) {
            addCriterion("INLET_DIAMETER <=", value, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterIn(List<BigDecimal> values) {
            addCriterion("INLET_DIAMETER in", values, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterNotIn(List<BigDecimal> values) {
            addCriterion("INLET_DIAMETER not in", values, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INLET_DIAMETER between", value1, value2, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletDiameterNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INLET_DIAMETER not between", value1, value2, "inletDiameter");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessIsNull() {
            addCriterion("INLET_WALL_THICKNESS is null");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessIsNotNull() {
            addCriterion("INLET_WALL_THICKNESS is not null");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessEqualTo(BigDecimal value) {
            addCriterion("INLET_WALL_THICKNESS =", value, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessNotEqualTo(BigDecimal value) {
            addCriterion("INLET_WALL_THICKNESS <>", value, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessGreaterThan(BigDecimal value) {
            addCriterion("INLET_WALL_THICKNESS >", value, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("INLET_WALL_THICKNESS >=", value, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessLessThan(BigDecimal value) {
            addCriterion("INLET_WALL_THICKNESS <", value, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessLessThanOrEqualTo(BigDecimal value) {
            addCriterion("INLET_WALL_THICKNESS <=", value, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessIn(List<BigDecimal> values) {
            addCriterion("INLET_WALL_THICKNESS in", values, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessNotIn(List<BigDecimal> values) {
            addCriterion("INLET_WALL_THICKNESS not in", values, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INLET_WALL_THICKNESS between", value1, value2, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andInletWallThicknessNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INLET_WALL_THICKNESS not between", value1, value2, "inletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeIsNull() {
            addCriterion("OUTLET_CONNECTION_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeIsNotNull() {
            addCriterion("OUTLET_CONNECTION_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeEqualTo(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE =", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeNotEqualTo(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE <>", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeGreaterThan(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE >", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeGreaterThanOrEqualTo(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE >=", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeLessThan(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE <", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeLessThanOrEqualTo(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE <=", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeLike(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE like", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeNotLike(String value) {
            addCriterion("OUTLET_CONNECTION_TYPE not like", value, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeIn(List<String> values) {
            addCriterion("OUTLET_CONNECTION_TYPE in", values, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeNotIn(List<String> values) {
            addCriterion("OUTLET_CONNECTION_TYPE not in", values, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeBetween(String value1, String value2) {
            addCriterion("OUTLET_CONNECTION_TYPE between", value1, value2, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletConnectionTypeNotBetween(String value1, String value2) {
            addCriterion("OUTLET_CONNECTION_TYPE not between", value1, value2, "outletConnectionType");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterIsNull() {
            addCriterion("OUTLET_DIAMETER is null");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterIsNotNull() {
            addCriterion("OUTLET_DIAMETER is not null");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterEqualTo(BigDecimal value) {
            addCriterion("OUTLET_DIAMETER =", value, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterNotEqualTo(BigDecimal value) {
            addCriterion("OUTLET_DIAMETER <>", value, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterGreaterThan(BigDecimal value) {
            addCriterion("OUTLET_DIAMETER >", value, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("OUTLET_DIAMETER >=", value, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterLessThan(BigDecimal value) {
            addCriterion("OUTLET_DIAMETER <", value, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterLessThanOrEqualTo(BigDecimal value) {
            addCriterion("OUTLET_DIAMETER <=", value, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterIn(List<BigDecimal> values) {
            addCriterion("OUTLET_DIAMETER in", values, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterNotIn(List<BigDecimal> values) {
            addCriterion("OUTLET_DIAMETER not in", values, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OUTLET_DIAMETER between", value1, value2, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletDiameterNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OUTLET_DIAMETER not between", value1, value2, "outletDiameter");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessIsNull() {
            addCriterion("OUTLET_WALL_THICKNESS is null");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessIsNotNull() {
            addCriterion("OUTLET_WALL_THICKNESS is not null");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessEqualTo(BigDecimal value) {
            addCriterion("OUTLET_WALL_THICKNESS =", value, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessNotEqualTo(BigDecimal value) {
            addCriterion("OUTLET_WALL_THICKNESS <>", value, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessGreaterThan(BigDecimal value) {
            addCriterion("OUTLET_WALL_THICKNESS >", value, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("OUTLET_WALL_THICKNESS >=", value, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessLessThan(BigDecimal value) {
            addCriterion("OUTLET_WALL_THICKNESS <", value, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessLessThanOrEqualTo(BigDecimal value) {
            addCriterion("OUTLET_WALL_THICKNESS <=", value, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessIn(List<BigDecimal> values) {
            addCriterion("OUTLET_WALL_THICKNESS in", values, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessNotIn(List<BigDecimal> values) {
            addCriterion("OUTLET_WALL_THICKNESS not in", values, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OUTLET_WALL_THICKNESS between", value1, value2, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andOutletWallThicknessNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OUTLET_WALL_THICKNESS not between", value1, value2, "outletWallThickness");
            return (Criteria) this;
        }

        public Criteria andPressureRatingIsNull() {
            addCriterion("PRESSURE_RATING is null");
            return (Criteria) this;
        }

        public Criteria andPressureRatingIsNotNull() {
            addCriterion("PRESSURE_RATING is not null");
            return (Criteria) this;
        }

        public Criteria andPressureRatingEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING =", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingNotEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING <>", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingGreaterThan(BigDecimal value) {
            addCriterion("PRESSURE_RATING >", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING >=", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingLessThan(BigDecimal value) {
            addCriterion("PRESSURE_RATING <", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING <=", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingIn(List<BigDecimal> values) {
            addCriterion("PRESSURE_RATING in", values, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingNotIn(List<BigDecimal> values) {
            addCriterion("PRESSURE_RATING not in", values, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRESSURE_RATING between", value1, value2, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRESSURE_RATING not between", value1, value2, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andValvefunctionIsNull() {
            addCriterion("VALVEFUNCTION is null");
            return (Criteria) this;
        }

        public Criteria andValvefunctionIsNotNull() {
            addCriterion("VALVEFUNCTION is not null");
            return (Criteria) this;
        }

        public Criteria andValvefunctionEqualTo(String value) {
            addCriterion("VALVEFUNCTION =", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionNotEqualTo(String value) {
            addCriterion("VALVEFUNCTION <>", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionGreaterThan(String value) {
            addCriterion("VALVEFUNCTION >", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionGreaterThanOrEqualTo(String value) {
            addCriterion("VALVEFUNCTION >=", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionLessThan(String value) {
            addCriterion("VALVEFUNCTION <", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionLessThanOrEqualTo(String value) {
            addCriterion("VALVEFUNCTION <=", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionLike(String value) {
            addCriterion("VALVEFUNCTION like", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionNotLike(String value) {
            addCriterion("VALVEFUNCTION not like", value, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionIn(List<String> values) {
            addCriterion("VALVEFUNCTION in", values, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionNotIn(List<String> values) {
            addCriterion("VALVEFUNCTION not in", values, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionBetween(String value1, String value2) {
            addCriterion("VALVEFUNCTION between", value1, value2, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andValvefunctionNotBetween(String value1, String value2) {
            addCriterion("VALVEFUNCTION not between", value1, value2, "valvefunction");
            return (Criteria) this;
        }

        public Criteria andIndremoteconIsNull() {
            addCriterion("INDREMOTECON is null");
            return (Criteria) this;
        }

        public Criteria andIndremoteconIsNotNull() {
            addCriterion("INDREMOTECON is not null");
            return (Criteria) this;
        }

        public Criteria andIndremoteconEqualTo(String value) {
            addCriterion("INDREMOTECON =", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconNotEqualTo(String value) {
            addCriterion("INDREMOTECON <>", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconGreaterThan(String value) {
            addCriterion("INDREMOTECON >", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconGreaterThanOrEqualTo(String value) {
            addCriterion("INDREMOTECON >=", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconLessThan(String value) {
            addCriterion("INDREMOTECON <", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconLessThanOrEqualTo(String value) {
            addCriterion("INDREMOTECON <=", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconLike(String value) {
            addCriterion("INDREMOTECON like", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconNotLike(String value) {
            addCriterion("INDREMOTECON not like", value, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconIn(List<String> values) {
            addCriterion("INDREMOTECON in", values, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconNotIn(List<String> values) {
            addCriterion("INDREMOTECON not in", values, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconBetween(String value1, String value2) {
            addCriterion("INDREMOTECON between", value1, value2, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andIndremoteconNotBetween(String value1, String value2) {
            addCriterion("INDREMOTECON not between", value1, value2, "indremotecon");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongIsNull() {
            addCriterion("REPAIR_SUGGESTIONG is null");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongIsNotNull() {
            addCriterion("REPAIR_SUGGESTIONG is not null");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongEqualTo(String value) {
            addCriterion("REPAIR_SUGGESTIONG =", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongNotEqualTo(String value) {
            addCriterion("REPAIR_SUGGESTIONG <>", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongGreaterThan(String value) {
            addCriterion("REPAIR_SUGGESTIONG >", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongGreaterThanOrEqualTo(String value) {
            addCriterion("REPAIR_SUGGESTIONG >=", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongLessThan(String value) {
            addCriterion("REPAIR_SUGGESTIONG <", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongLessThanOrEqualTo(String value) {
            addCriterion("REPAIR_SUGGESTIONG <=", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongLike(String value) {
            addCriterion("REPAIR_SUGGESTIONG like", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongNotLike(String value) {
            addCriterion("REPAIR_SUGGESTIONG not like", value, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongIn(List<String> values) {
            addCriterion("REPAIR_SUGGESTIONG in", values, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongNotIn(List<String> values) {
            addCriterion("REPAIR_SUGGESTIONG not in", values, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongBetween(String value1, String value2) {
            addCriterion("REPAIR_SUGGESTIONG between", value1, value2, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairSuggestiongNotBetween(String value1, String value2) {
            addCriterion("REPAIR_SUGGESTIONG not between", value1, value2, "repairSuggestiong");
            return (Criteria) this;
        }

        public Criteria andRepairStateIsNull() {
            addCriterion("REPAIR_STATE is null");
            return (Criteria) this;
        }

        public Criteria andRepairStateIsNotNull() {
            addCriterion("REPAIR_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andRepairStateEqualTo(String value) {
            addCriterion("REPAIR_STATE =", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateNotEqualTo(String value) {
            addCriterion("REPAIR_STATE <>", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateGreaterThan(String value) {
            addCriterion("REPAIR_STATE >", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateGreaterThanOrEqualTo(String value) {
            addCriterion("REPAIR_STATE >=", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateLessThan(String value) {
            addCriterion("REPAIR_STATE <", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateLessThanOrEqualTo(String value) {
            addCriterion("REPAIR_STATE <=", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateLike(String value) {
            addCriterion("REPAIR_STATE like", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateNotLike(String value) {
            addCriterion("REPAIR_STATE not like", value, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateIn(List<String> values) {
            addCriterion("REPAIR_STATE in", values, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateNotIn(List<String> values) {
            addCriterion("REPAIR_STATE not in", values, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateBetween(String value1, String value2) {
            addCriterion("REPAIR_STATE between", value1, value2, "repairState");
            return (Criteria) this;
        }

        public Criteria andRepairStateNotBetween(String value1, String value2) {
            addCriterion("REPAIR_STATE not between", value1, value2, "repairState");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNull() {
            addCriterion("MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNotNull() {
            addCriterion("MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerEqualTo(String value) {
            addCriterion("MANUFACTURER =", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotEqualTo(String value) {
            addCriterion("MANUFACTURER <>", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThan(String value) {
            addCriterion("MANUFACTURER >", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("MANUFACTURER >=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThan(String value) {
            addCriterion("MANUFACTURER <", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThanOrEqualTo(String value) {
            addCriterion("MANUFACTURER <=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLike(String value) {
            addCriterion("MANUFACTURER like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotLike(String value) {
            addCriterion("MANUFACTURER not like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerIn(List<String> values) {
            addCriterion("MANUFACTURER in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotIn(List<String> values) {
            addCriterion("MANUFACTURER not in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerBetween(String value1, String value2) {
            addCriterion("MANUFACTURER between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotBetween(String value1, String value2) {
            addCriterion("MANUFACTURER not between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateIsNull() {
            addCriterion("MANUFACTURED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateIsNotNull() {
            addCriterion("MANUFACTURED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateEqualTo(Date value) {
            addCriterion("MANUFACTURED_DATE =", value, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateNotEqualTo(Date value) {
            addCriterion("MANUFACTURED_DATE <>", value, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateGreaterThan(Date value) {
            addCriterion("MANUFACTURED_DATE >", value, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("MANUFACTURED_DATE >=", value, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateLessThan(Date value) {
            addCriterion("MANUFACTURED_DATE <", value, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateLessThanOrEqualTo(Date value) {
            addCriterion("MANUFACTURED_DATE <=", value, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateIn(List<Date> values) {
            addCriterion("MANUFACTURED_DATE in", values, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateNotIn(List<Date> values) {
            addCriterion("MANUFACTURED_DATE not in", values, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateBetween(Date value1, Date value2) {
            addCriterion("MANUFACTURED_DATE between", value1, value2, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andManufacturedDateNotBetween(Date value1, Date value2) {
            addCriterion("MANUFACTURED_DATE not between", value1, value2, "manufacturedDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateIsNull() {
            addCriterion("INSERVICE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInserviceDateIsNotNull() {
            addCriterion("INSERVICE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInserviceDateEqualTo(Date value) {
            addCriterion("INSERVICE_DATE =", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateNotEqualTo(Date value) {
            addCriterion("INSERVICE_DATE <>", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateGreaterThan(Date value) {
            addCriterion("INSERVICE_DATE >", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateGreaterThanOrEqualTo(Date value) {
            addCriterion("INSERVICE_DATE >=", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateLessThan(Date value) {
            addCriterion("INSERVICE_DATE <", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateLessThanOrEqualTo(Date value) {
            addCriterion("INSERVICE_DATE <=", value, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateIn(List<Date> values) {
            addCriterion("INSERVICE_DATE in", values, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateNotIn(List<Date> values) {
            addCriterion("INSERVICE_DATE not in", values, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateBetween(Date value1, Date value2) {
            addCriterion("INSERVICE_DATE between", value1, value2, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andInserviceDateNotBetween(Date value1, Date value2) {
            addCriterion("INSERVICE_DATE not between", value1, value2, "inserviceDate");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyIsNull() {
            addCriterion("CONSTRUCTION_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyIsNotNull() {
            addCriterion("CONSTRUCTION_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyEqualTo(String value) {
            addCriterion("CONSTRUCTION_COMPANY =", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyNotEqualTo(String value) {
            addCriterion("CONSTRUCTION_COMPANY <>", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyGreaterThan(String value) {
            addCriterion("CONSTRUCTION_COMPANY >", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("CONSTRUCTION_COMPANY >=", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyLessThan(String value) {
            addCriterion("CONSTRUCTION_COMPANY <", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyLessThanOrEqualTo(String value) {
            addCriterion("CONSTRUCTION_COMPANY <=", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyLike(String value) {
            addCriterion("CONSTRUCTION_COMPANY like", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyNotLike(String value) {
            addCriterion("CONSTRUCTION_COMPANY not like", value, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyIn(List<String> values) {
            addCriterion("CONSTRUCTION_COMPANY in", values, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyNotIn(List<String> values) {
            addCriterion("CONSTRUCTION_COMPANY not in", values, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyBetween(String value1, String value2) {
            addCriterion("CONSTRUCTION_COMPANY between", value1, value2, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andConstructionCompanyNotBetween(String value1, String value2) {
            addCriterion("CONSTRUCTION_COMPANY not between", value1, value2, "constructionCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyIsNull() {
            addCriterion("INSPECTING_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyIsNotNull() {
            addCriterion("INSPECTING_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyEqualTo(String value) {
            addCriterion("INSPECTING_COMPANY =", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyNotEqualTo(String value) {
            addCriterion("INSPECTING_COMPANY <>", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyGreaterThan(String value) {
            addCriterion("INSPECTING_COMPANY >", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("INSPECTING_COMPANY >=", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyLessThan(String value) {
            addCriterion("INSPECTING_COMPANY <", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyLessThanOrEqualTo(String value) {
            addCriterion("INSPECTING_COMPANY <=", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyLike(String value) {
            addCriterion("INSPECTING_COMPANY like", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyNotLike(String value) {
            addCriterion("INSPECTING_COMPANY not like", value, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyIn(List<String> values) {
            addCriterion("INSPECTING_COMPANY in", values, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyNotIn(List<String> values) {
            addCriterion("INSPECTING_COMPANY not in", values, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyBetween(String value1, String value2) {
            addCriterion("INSPECTING_COMPANY between", value1, value2, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andInspectingCompanyNotBetween(String value1, String value2) {
            addCriterion("INSPECTING_COMPANY not between", value1, value2, "inspectingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIsNull() {
            addCriterion("TESTING_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIsNotNull() {
            addCriterion("TESTING_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyEqualTo(String value) {
            addCriterion("TESTING_COMPANY =", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotEqualTo(String value) {
            addCriterion("TESTING_COMPANY <>", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyGreaterThan(String value) {
            addCriterion("TESTING_COMPANY >", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("TESTING_COMPANY >=", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLessThan(String value) {
            addCriterion("TESTING_COMPANY <", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLessThanOrEqualTo(String value) {
            addCriterion("TESTING_COMPANY <=", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLike(String value) {
            addCriterion("TESTING_COMPANY like", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotLike(String value) {
            addCriterion("TESTING_COMPANY not like", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIn(List<String> values) {
            addCriterion("TESTING_COMPANY in", values, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotIn(List<String> values) {
            addCriterion("TESTING_COMPANY not in", values, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyBetween(String value1, String value2) {
            addCriterion("TESTING_COMPANY between", value1, value2, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotBetween(String value1, String value2) {
            addCriterion("TESTING_COMPANY not between", value1, value2, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andMileageIsNull() {
            addCriterion("MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andMileageIsNotNull() {
            addCriterion("MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andMileageEqualTo(BigDecimal value) {
            addCriterion("MILEAGE =", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageNotEqualTo(BigDecimal value) {
            addCriterion("MILEAGE <>", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageGreaterThan(BigDecimal value) {
            addCriterion("MILEAGE >", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MILEAGE >=", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageLessThan(BigDecimal value) {
            addCriterion("MILEAGE <", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MILEAGE <=", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageIn(List<BigDecimal> values) {
            addCriterion("MILEAGE in", values, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageNotIn(List<BigDecimal> values) {
            addCriterion("MILEAGE not in", values, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MILEAGE between", value1, value2, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MILEAGE not between", value1, value2, "mileage");
            return (Criteria) this;
        }

        public Criteria andReferenceIsNull() {
            addCriterion("REFERENCE is null");
            return (Criteria) this;
        }

        public Criteria andReferenceIsNotNull() {
            addCriterion("REFERENCE is not null");
            return (Criteria) this;
        }

        public Criteria andReferenceEqualTo(String value) {
            addCriterion("REFERENCE =", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceNotEqualTo(String value) {
            addCriterion("REFERENCE <>", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceGreaterThan(String value) {
            addCriterion("REFERENCE >", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceGreaterThanOrEqualTo(String value) {
            addCriterion("REFERENCE >=", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceLessThan(String value) {
            addCriterion("REFERENCE <", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceLessThanOrEqualTo(String value) {
            addCriterion("REFERENCE <=", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceLike(String value) {
            addCriterion("REFERENCE like", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceNotLike(String value) {
            addCriterion("REFERENCE not like", value, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceIn(List<String> values) {
            addCriterion("REFERENCE in", values, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceNotIn(List<String> values) {
            addCriterion("REFERENCE not in", values, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceBetween(String value1, String value2) {
            addCriterion("REFERENCE between", value1, value2, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceNotBetween(String value1, String value2) {
            addCriterion("REFERENCE not between", value1, value2, "reference");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceIsNull() {
            addCriterion("REFERENCE_DISTANCE is null");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceIsNotNull() {
            addCriterion("REFERENCE_DISTANCE is not null");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceEqualTo(BigDecimal value) {
            addCriterion("REFERENCE_DISTANCE =", value, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceNotEqualTo(BigDecimal value) {
            addCriterion("REFERENCE_DISTANCE <>", value, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceGreaterThan(BigDecimal value) {
            addCriterion("REFERENCE_DISTANCE >", value, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("REFERENCE_DISTANCE >=", value, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceLessThan(BigDecimal value) {
            addCriterion("REFERENCE_DISTANCE <", value, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("REFERENCE_DISTANCE <=", value, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceIn(List<BigDecimal> values) {
            addCriterion("REFERENCE_DISTANCE in", values, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceNotIn(List<BigDecimal> values) {
            addCriterion("REFERENCE_DISTANCE not in", values, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("REFERENCE_DISTANCE between", value1, value2, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceDistanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("REFERENCE_DISTANCE not between", value1, value2, "referenceDistance");
            return (Criteria) this;
        }

        public Criteria andReferenceIdIsNull() {
            addCriterion("REFERENCE_ID is null");
            return (Criteria) this;
        }

        public Criteria andReferenceIdIsNotNull() {
            addCriterion("REFERENCE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andReferenceIdEqualTo(String value) {
            addCriterion("REFERENCE_ID =", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdNotEqualTo(String value) {
            addCriterion("REFERENCE_ID <>", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdGreaterThan(String value) {
            addCriterion("REFERENCE_ID >", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdGreaterThanOrEqualTo(String value) {
            addCriterion("REFERENCE_ID >=", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdLessThan(String value) {
            addCriterion("REFERENCE_ID <", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdLessThanOrEqualTo(String value) {
            addCriterion("REFERENCE_ID <=", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdLike(String value) {
            addCriterion("REFERENCE_ID like", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdNotLike(String value) {
            addCriterion("REFERENCE_ID not like", value, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdIn(List<String> values) {
            addCriterion("REFERENCE_ID in", values, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdNotIn(List<String> values) {
            addCriterion("REFERENCE_ID not in", values, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdBetween(String value1, String value2) {
            addCriterion("REFERENCE_ID between", value1, value2, "referenceId");
            return (Criteria) this;
        }

        public Criteria andReferenceIdNotBetween(String value1, String value2) {
            addCriterion("REFERENCE_ID not between", value1, value2, "referenceId");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNull() {
            addCriterion("RECORDER is null");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNotNull() {
            addCriterion("RECORDER is not null");
            return (Criteria) this;
        }

        public Criteria andRecorderEqualTo(String value) {
            addCriterion("RECORDER =", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotEqualTo(String value) {
            addCriterion("RECORDER <>", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThan(String value) {
            addCriterion("RECORDER >", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThanOrEqualTo(String value) {
            addCriterion("RECORDER >=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThan(String value) {
            addCriterion("RECORDER <", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThanOrEqualTo(String value) {
            addCriterion("RECORDER <=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLike(String value) {
            addCriterion("RECORDER like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotLike(String value) {
            addCriterion("RECORDER not like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderIn(List<String> values) {
            addCriterion("RECORDER in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotIn(List<String> values) {
            addCriterion("RECORDER not in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderBetween(String value1, String value2) {
            addCriterion("RECORDER between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotBetween(String value1, String value2) {
            addCriterion("RECORDER not between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIsNull() {
            addCriterion("RECORDTIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIsNotNull() {
            addCriterion("RECORDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordtimeEqualTo(Date value) {
            addCriterion("RECORDTIME =", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotEqualTo(Date value) {
            addCriterion("RECORDTIME <>", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeGreaterThan(Date value) {
            addCriterion("RECORDTIME >", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORDTIME >=", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeLessThan(Date value) {
            addCriterion("RECORDTIME <", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORDTIME <=", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIn(List<Date> values) {
            addCriterion("RECORDTIME in", values, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotIn(List<Date> values) {
            addCriterion("RECORDTIME not in", values, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeBetween(Date value1, Date value2) {
            addCriterion("RECORDTIME between", value1, value2, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORDTIME not between", value1, value2, "recordtime");
            return (Criteria) this;
        }

        public Criteria andGisIdIsNull() {
            addCriterion("GIS_ID is null");
            return (Criteria) this;
        }

        public Criteria andGisIdIsNotNull() {
            addCriterion("GIS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andGisIdEqualTo(String value) {
            addCriterion("GIS_ID =", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotEqualTo(String value) {
            addCriterion("GIS_ID <>", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdGreaterThan(String value) {
            addCriterion("GIS_ID >", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdGreaterThanOrEqualTo(String value) {
            addCriterion("GIS_ID >=", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdLessThan(String value) {
            addCriterion("GIS_ID <", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdLessThanOrEqualTo(String value) {
            addCriterion("GIS_ID <=", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdLike(String value) {
            addCriterion("GIS_ID like", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotLike(String value) {
            addCriterion("GIS_ID not like", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdIn(List<String> values) {
            addCriterion("GIS_ID in", values, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotIn(List<String> values) {
            addCriterion("GIS_ID not in", values, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdBetween(String value1, String value2) {
            addCriterion("GIS_ID between", value1, value2, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotBetween(String value1, String value2) {
            addCriterion("GIS_ID not between", value1, value2, "gisId");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNull() {
            addCriterion("ORG_BIZ_PATH is null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNotNull() {
            addCriterion("ORG_BIZ_PATH is not null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH =", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <>", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThan(String value) {
            addCriterion("ORG_BIZ_PATH >", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH >=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThan(String value) {
            addCriterion("ORG_BIZ_PATH <", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLike(String value) {
            addCriterion("ORG_BIZ_PATH like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotLike(String value) {
            addCriterion("ORG_BIZ_PATH not like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH not in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH not between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}